First, we map all the client zip codes in North Carolina.
For the zip codes that are not in North Carolina, one zip code is from Virginia (with one client), one zip code is from West Virginia (with one client) and the rest are typos.
Five counties contain all the zip codes with at least 5 client households: Orange, Durham, Franklin, Wake, and Johnston. Most of the zip codes lie within Wake county.
Below is a map of the zip codes in Wake County, taken from https://www.cccarto.com/nc/wake_zipcodes/.
Needs mapping
First, we plot the number of household units and the need as represented by lower Per Capita Income (PCI). These two variables are taken from the CDC Social Vulnerability Index.
Below shows the number of household units in each zip code that contains at least 5 TGCP client households. Wake County is outlined in green.
Below is the same map, overlaid over Google Maps.
Below shows the Per Capita Income of each zip code.
Below ranks the zip code according to PCI. That is, the rank of 1 is assigned to the highest PCI, and the last rank of 44 is assigned to the lowest PCI. Thus, a higher rank corresponds to higher need.
Met Needs Mapping
The below map shows the number of client households served by TGCP at each zip code.
Below is the same map, overlaid over Google Maps.
Below ranks the zip code according to the proportion of households served. That is, the rank of 1 corresponds to the lowest proportion of households served, and the last rank of 44 corresponds to the highest proportion of households served. Thus, a higher rank corresponds to more service, or “needs met”.
Unmet Needs Plot
To measure “unmet need,” I take the difference of the PCI ranking (representing the “need”) and the proportion of households served ranking (representing the “met need”).
Below is the same map, overlaid over Google Maps.
